ICDL Excel: A step-by-step guide to spreadsheets using Microsoft Excel by Conor Jordan

Author:Conor Jordan [Jordan, Conor]
Language: eng
Format: azw3, epub
Published: 2020-10-18T16:00:00+00:00

Click on the To Book drop-down box

Select New Book

Click OK

The worksheet will be moved to a new workbook

Save the “Annual Sales” workbook

Close the new workbook without saving

Revision – Section 3

Open the “Company Sales” workbook

Highlight columns B to D

Insert 3 extra columns

Change the column widths to 10 units wide

Apply Freeze Panes to the first two rows

Add a new worksheet and name it Sales

Save the workbook as “Calculated Sales”

Section 3 – Formulas

A Formula is a calculation that begins with an Equals sign. It contains numbers or cell references calculated with maths symbols e.g. =B2+B3

It is good practice to use cell references rather than numbers in formulas, that way, if the value of the cell changes, the formula will still work.

You can Add cell values by first entering in numbers to cells A1 and A2, then in A3 enter the following calculation:

=A1+A2

Open a new workbook

In cell A1 enter in the value 34

In cell A2 enter 56

In cell A3 enter the following formula:

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.